package com.app.dao.yj;

import com.app.domain.yj.YjjlData;
import com.app.domain.yj.YjjlInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

@Mapper
public interface YjMapper {

    @Select("select * from yjjl_data")
    public List<YjjlData> findAllYjjlData();

    List<YjjlInfo> queryYjlInfoPage(String searchIsAll);

    @Select("SELECT  * FROM yjjl_info WHERE id = #{id}")
    YjjlInfo queryYjjlInfoById(int id);

    @Select("select * from yjjl_data where qlbh=#{qlbh}")
   List<YjjlData> findYjjlDataByQlbh(String qlbh);
    @Update("update yjjl_info set UPLOADED = #{uploaded}  where id = #{yjjlInfoId}")
    void updateYjjlInfo(@Param("uploaded") String uploaded, @Param("yjjlInfoId") Integer yjjlInfoId);
}
